'Declaration
 
Public Function New( _
   ByVal tableId As String, _
   ByVal firstRowAreColumnNames As Boolean, _
   ByVal sheetNames As ReadOnlyCollection(Of String), _
   ByVal refreshToken As String, _
   ByVal clientId As String, _
   ByVal clientSecret As String _
)

public GoogleSpreadsheetsDataProvider( 
   string tableId,
   bool firstRowAreColumnNames,
   ReadOnlyCollection<string> sheetNames,
   string refreshToken,
   string clientId,
   string clientSecret
)

public:
GoogleSpreadsheetsDataProvider( 
   String^ tableId,
   bool firstRowAreColumnNames,
   ReadOnlyCollection<String^>^ sheetNames,
   String^ refreshToken,
   String^ clientId,
   String^ clientSecret
)

Parameters

tableId

See the data provider description.

firstRowAreColumnNames

First row should be used as header (i.e. the contents are used as column names).

sheetNames

The List of spreadsheets  that  should  be provided as tables.

refreshToken

You need to generate the Refresh Token once, for example by using combit Google Token Generator.  This token never expires on its own.

clientId

Client ID. Can be found in the Google Developers Console under "Project name" > APIs & Auth > Credentials

clientSecret

Client Secret. Can be found in the Google Developers Console under "Project name" > APIs & Auth > Credentials

Platforms: Windows 10 (Version 21H2 - 23H2), Windows 11 (21H2 - 22H2), Windows Server 2016 - 2022
.NET: .NET Framework 4.8, .NET 6, .NET 7, .NET 8

Reference

GoogleSpreadsheetsDataProvider Class
GoogleSpreadsheetsDataProvider Members
Overload List